﻿--获取一个网站的制作人员
create proc [dbo].[proc_SitePersonnel_GetList]
(
	@sid int
)
as
	select 
		sp.id,
		sp.departmentid,
		(select d.dname from department d where d.id=sp.departmentid) as departmentname,
		(select e.ename from employee e where e.username=sp.username) as username
	from
		SitePersonnel sp
	where 
		sp.sid = @sid
